package com.caocaog.market.mapper;

import com.alibaba.fastjson.JSONObject;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.caocaog.market.entity.ShopMemberBind;
import org.apache.ibatis.annotations.Select;

/**
 * 店铺与账号绑定
 *
 * @author chechen
 * @date 2021-12-21
 */
public interface ShopMemberBindMapper extends BaseMapper<ShopMemberBind> {

    @DS("sql-server-datasource")
    @Select("SELECT TOP 1 sid, login_name FROM cc_member WHERE login_name = #{loginName}")
    JSONObject getMemberLoginName(String loginName);
}
